import sqlite3

# 修改表结构

def modify_table():
    conn = sqlite3.connect('contest.db')
    c = conn.cursor()
    sql = '''DROP TABLE IF EXISTS feedback;'''
    c.execute(sql)
    sql3 = '''CREATE TABLE IF NOT EXISTS feedback
            (id INTEGER PRIMARY KEY,
            content TEXT NOT NULL,
            time TEXT NOT NULL,
            type TEXT NOT NULL,
            pages INTEGER NOT NULL,
            status TEXT NOT NULL
            )'''
    c.execute(sql3)
    conn.commit()
    conn.close()

if __name__ == '__main__':
    modify_table()
    print('修改成功')